Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	1003
Missing cells	51
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	133.3 KiB
Average record size in memory	136.1 B

Variable types

Categorical	5
Numeric	12

Alerts

`title` has a high cardinality: 945 distinct values	High cardinality
`artist` has a high cardinality: 444 distinct values	High cardinality
`top genre` has a high cardinality: 132 distinct values	High cardinality
`year released` is highly correlated with `top year`	High correlation
`nrgy` is highly correlated with `dB`	High correlation
`dB` is highly correlated with `nrgy`	High correlation
`top year` is highly correlated with `year released`	High correlation
`year released` is highly correlated with `top year`	High correlation
`nrgy` is highly correlated with `dB` and 1 other fields	High correlation
`dB` is highly correlated with `nrgy`	High correlation
`acous` is highly correlated with `nrgy`	High correlation
`top year` is highly correlated with `year released`	High correlation
`year released` is highly correlated with `top year`	High correlation
`nrgy` is highly correlated with `dB`	High correlation
`dB` is highly correlated with `nrgy`	High correlation
`top year` is highly correlated with `year released`	High correlation
`year released` is highly correlated with `added` and 1 other fields	High correlation
`added` is highly correlated with `year released` and 2 other fields	High correlation
`bpm` is highly correlated with `dnce`	High correlation
`nrgy` is highly correlated with `dB` and 1 other fields	High correlation
`dnce` is highly correlated with `bpm`	High correlation
`dB` is highly correlated with `added` and 2 other fields	High correlation
`acous` is highly correlated with `nrgy` and 1 other fields	High correlation
`top year` is highly correlated with `year released` and 1 other fields	High correlation
`title` is uniformly distributed	Uniform
`acous` has 134 (13.4%) zeros	Zeros

Reproduction

Analysis started	2022-04-14 15:28:25.714465
Analysis finished	2022-04-14 15:29:21.487949
Duration	55.77 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	945
Distinct (%)	94.5%
Missing	3
Missing (%)	0.3%
Memory size	8.0 KiB

Don't	3
Sorry	3
Paradise	3
Team	2
No Hands (feat. Roscoe Dash & Wale)	2
Other values (940)	987

Length

Max length	94
Median length	13
Mean length	17.249
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	893 ?
Unique (%)	89.3%

Sample

1st row	STARSTRUKK (feat. Katy Perry)
2nd row	My First Kiss (feat. Ke$ha)
3rd row	I Need A Dollar
4th row	Airplanes (feat. Hayley Williams of Paramore)
5th row	Nothin' on You (feat. Bruno Mars)

Common Values

Value	Count	Frequency (%)
Don't	3	0.3%
Sorry	3	0.3%
Paradise	3	0.3%
Team	2	0.2%
No Hands (feat. Roscoe Dash & Wale)	2	0.2%
Better Now	2	0.2%
lovely (with Khalid)	2	0.2%
All My Friends (feat. Tinashe & Chance the Rapper)	2	0.2%
Stole the Show	2	0.2%
I Knew You Were Trouble.	2	0.2%
Other values (935)	977	97.4%
(Missing)	3	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
feat	172	5.2%
	111	3.3%
the	92	2.8%
you	60	1.8%
love	55	1.7%
me	51	1.5%
i	48	1.4%
it	38	1.1%
edit	34	1.0%
my	33	1.0%
Other values (1290)	2629	79.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

artist
Categorical

HIGH CARDINALITY

Distinct	444
Distinct (%)	44.4%
Missing	3
Missing (%)	0.3%
Memory size	8.0 KiB

Taylor Swift	21
Drake	18
Calvin Harris	18
Rihanna	14
Ariana Grande	14
Other values (439)	915

Length

Max length	24
Median length	10
Mean length	10.03
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	250 ?
Unique (%)	25.0%

Sample

1st row	3OH!3
2nd row	3OH!3
3rd row	Aloe Blacc
4th row	B.o.B
5th row	B.o.B

Common Values

Value	Count	Frequency (%)
Taylor Swift	21	2.1%
Drake	18	1.8%
Calvin Harris	18	1.8%
Rihanna	14	1.4%
Ariana Grande	14	1.4%
Bruno Mars	13	1.3%
Maroon 5	11	1.1%
Post Malone	10	1.0%
Chris Brown	10	1.0%
Jason Derulo	10	1.0%
Other values (434)	861	85.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	50	2.8%
taylor	21	1.2%
swift	21	1.2%
	20	1.1%
harris	18	1.0%
drake	18	1.0%
calvin	18	1.0%
5	15	0.8%
rihanna	14	0.8%
ariana	14	0.8%
Other values (686)	1587	88.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

top genre
Categorical

HIGH CARDINALITY

Distinct	132
Distinct (%)	13.2%
Missing	3
Missing (%)	0.3%
Memory size	8.0 KiB

dance pop	361
pop	57
atl hip hop	39
art pop	37
boy band	21
Other values (127)	485

Length

Max length	25
Median length	9
Mean length	9.983
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	52 ?
Unique (%)	5.2%

Sample

1st row	dance pop
2nd row	dance pop
3rd row	pop soul
4th row	atl hip hop
5th row	atl hip hop

Common Values

Value	Count	Frequency (%)
dance pop	361	36.0%
pop	57	5.7%
atl hip hop	39	3.9%
art pop	37	3.7%
boy band	21	2.1%
hip hop	21	2.1%
canadian hip hop	18	1.8%
edm	17	1.7%
folk-pop	15	1.5%
contemporary country	14	1.4%
Other values (122)	400	39.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pop	527	26.3%
dance	372	18.6%
hip	127	6.3%
hop	126	6.3%
rap	73	3.6%
canadian	42	2.1%
rock	40	2.0%
atl	39	1.9%
art	37	1.8%
modern	27	1.3%
Other values (129)	592	29.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

year released
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	14
Distinct (%)	1.4%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	2014.39

Minimum	1975
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	1975
5-th percentile	2010
Q1	2012
median	2014
Q3	2017
95-th percentile	2019
Maximum	2021
Range	46
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.241358728
Coefficient of variation (CV)	0.001609101876
Kurtosis	20.2898332
Mean	2014.39
Median Absolute Deviation (MAD)	3
Skewness	-1.776445005
Sum	2014390
Variance	10.50640641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2018	112	11.2%
2012	109	10.9%
2014	101	10.1%
2017	99	9.9%
2015	99	9.9%
2010	94	9.4%
2011	93	9.3%
2019	87	8.7%
2013	86	8.6%
2016	86	8.6%
Other values (4)	34	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1975	1	0.1%
2009	24	2.4%
2010	94	9.4%
2011	93	9.3%
2012	109	10.9%
2013	86	8.6%
2014	101	10.1%
2015	99	9.9%
2016	86	8.6%
2017	99	9.9%

Value	Count	Frequency (%)
2021	3	0.3%
2020	6	0.6%
2019	87	8.7%
2018	112	11.2%
2017	99	9.9%
2016	86	8.6%
2015	99	9.9%
2014	101	10.1%
2013	86	8.6%
2012	109	10.9%

added
Categorical

HIGH CORRELATION

Distinct	26
Distinct (%)	2.6%
Missing	3
Missing (%)	0.3%
Memory size	8.0 KiB

2020‑06‑22	276
2022‑02‑17	100
2020‑06‑11	100
2020‑06‑16	99
2020‑06‑10	94
Other values (21)	331

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.8%

Sample

1st row	2022‑02‑17
2nd row	2022‑02‑17
3rd row	2022‑02‑17
4th row	2022‑02‑17
5th row	2022‑02‑17

Common Values

Value	Count	Frequency (%)
2020‑06‑22	276	27.5%
2022‑02‑17	100	10.0%
2020‑06‑11	100	10.0%
2020‑06‑16	99	9.9%
2020‑06‑10	94	9.4%
2021‑01‑28	91	9.1%
2020‑06‑08	87	8.7%
2020‑06‑19	85	8.5%
2021‑08‑09	14	1.4%
2021‑08‑17	10	1.0%
Other values (16)	44	4.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020‑06‑22	276	27.6%
2020‑06‑11	100	10.0%
2022‑02‑17	100	10.0%
2020‑06‑16	99	9.9%
2020‑06‑10	94	9.4%
2021‑01‑28	91	9.1%
2020‑06‑08	87	8.7%
2020‑06‑19	85	8.5%
2021‑08‑09	14	1.4%
2021‑08‑17	10	1.0%
Other values (16)	44	4.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

bpm
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	122
Distinct (%)	12.2%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	121.262

Minimum	65
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	65
5-th percentile	82
Q1	100
median	122
Q3	134
95-th percentile	172
Maximum	206
Range	141
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	26.23802183
Coefficient of variation (CV)	0.216374642
Kurtosis	0.2452450595
Mean	121.262
Median Absolute Deviation (MAD)	18
Skewness	0.5494200137
Sum	121262
Variance	688.4337898
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
128	57	5.7%
120	55	5.5%
100	40	4.0%
125	35	3.5%
126	33	3.3%
130	33	3.3%
140	23	2.3%
95	22	2.2%
122	20	2.0%
98	17	1.7%
Other values (112)	665	66.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
65	2	0.2%
69	1	0.1%
72	2	0.2%
73	2	0.2%
74	3	0.3%
75	6	0.6%
76	5	0.5%
77	6	0.6%
78	2	0.2%
79	5	0.5%

Value	Count	Frequency (%)
206	2	0.2%
204	1	0.1%
202	2	0.2%
200	1	0.1%
198	1	0.1%
196	2	0.2%
192	2	0.2%
190	6	0.6%
188	2	0.2%
187	1	0.1%

nrgy
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	80
Distinct (%)	8.0%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	69.502

Minimum	6
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	6
5-th percentile	41
Q1	59
median	71
Q3	81.25
95-th percentile	92
Maximum	98
Range	92
Interquartile range (IQR)	22.25

Descriptive statistics

Standard deviation	15.96141481
Coefficient of variation (CV)	0.229654036
Kurtosis	0.1802383136
Mean	69.502
Median Absolute Deviation (MAD)	11
Skewness	-0.65086111
Sum	69502
Variance	254.7667628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
79	35	3.5%
73	30	3.0%
71	30	3.0%
81	29	2.9%
78	27	2.7%
80	26	2.6%
82	26	2.6%
84	25	2.5%
59	24	2.4%
76	24	2.4%
Other values (70)	724	72.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	0.1%
11	1	0.1%
15	1	0.1%
16	1	0.1%
17	1	0.1%
23	1	0.1%
25	2	0.2%
26	1	0.1%
27	1	0.1%
28	2	0.2%

Value	Count	Frequency (%)
98	2	0.2%
97	4	0.4%
96	4	0.4%
95	7	0.7%
94	10	1.0%
93	17	1.7%
92	16	1.6%
91	13	1.3%
90	7	0.7%
89	23	2.3%

dnce
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	68
Distinct (%)	6.8%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	66.876

Minimum	19
Maximum	96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	19
5-th percentile	42
Q1	59
median	68
Q3	75
95-th percentile	88
Maximum	96
Range	77
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	13.12192093
Coefficient of variation (CV)	0.196212706
Kurtosis	0.0936383514
Mean	66.876
Median Absolute Deviation (MAD)	8
Skewness	-0.411284933
Sum	66876
Variance	172.1848088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
67	42	4.2%
66	38	3.8%
68	37	3.7%
69	37	3.7%
75	37	3.7%
73	36	3.6%
65	35	3.5%
72	34	3.4%
61	31	3.1%
70	30	3.0%
Other values (58)	643	64.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	1	0.1%
26	1	0.1%
28	1	0.1%
31	4	0.4%
33	1	0.1%
34	1	0.1%
35	5	0.5%
36	4	0.4%
37	6	0.6%
38	7	0.7%

Value	Count	Frequency (%)
96	2	0.2%
95	1	0.1%
94	2	0.2%
93	7	0.7%
92	5	0.5%
91	10	1.0%
90	7	0.7%
89	13	1.3%
88	8	0.8%
87	7	0.7%

dB
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	16
Distinct (%)	1.6%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	-5.663

Minimum	-18
Maximum	-1
Zeros	0
Zeros (%)	0.0%
Negative	1000
Negative (%)	99.7%
Memory size	8.0 KiB

Quantile statistics

Minimum	-18
5-th percentile	-9
Q1	-7
median	-5
Q3	-4
95-th percentile	-3
Maximum	-1
Range	17
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.02522407
Coefficient of variation (CV)	-0.3576238866
Kurtosis	2.9972501
Mean	-5.663
Median Absolute Deviation (MAD)	1
Skewness	-1.156751472
Sum	-5663
Variance	4.101532533
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
-6	212	21.1%
-5	203	20.2%
-4	201	20.0%
-7	128	12.8%
-3	90	9.0%
-8	67	6.7%
-9	39	3.9%
-10	18	1.8%
-2	15	1.5%
-11	14	1.4%
Other values (6)	13	1.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-18	1	0.1%
-15	3	0.3%
-14	1	0.1%
-13	4	0.4%
-12	2	0.2%
-11	14	1.4%
-10	18	1.8%
-9	39	3.9%
-8	67	6.7%
-7	128	12.8%

Value	Count	Frequency (%)
-1	2	0.2%
-2	15	1.5%
-3	90	9.0%
-4	201	20.0%
-5	203	20.2%
-6	212	21.1%
-7	128	12.8%
-8	67	6.7%
-9	39	3.9%
-10	18	1.8%

live
Real number (ℝ_≥0)

Distinct	67
Distinct (%)	6.7%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	17.911

Minimum	2
Maximum	83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	2
5-th percentile	6
Q1	9
median	12
Q3	23
95-th percentile	44
Maximum	83
Range	81
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	13.43151088
Coefficient of variation (CV)	0.7499029021
Kurtosis	4.072649065
Mean	17.911
Median Absolute Deviation (MAD)	4
Skewness	1.916292267
Sum	17911
Variance	180.4054845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	93	9.3%
9	80	8.0%
8	72	7.2%
10	71	7.1%
12	69	6.9%
13	44	4.4%
7	43	4.3%
6	38	3.8%
14	36	3.6%
16	32	3.2%
Other values (57)	422	42.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	4	0.4%
3	6	0.6%
4	7	0.7%
5	21	2.1%
6	38	3.8%
7	43	4.3%
8	72	7.2%
9	80	8.0%
10	71	7.1%
11	93	9.3%

Value	Count	Frequency (%)
83	1	0.1%
82	1	0.1%
80	1	0.1%
74	2	0.2%
70	1	0.1%
69	4	0.4%
67	2	0.2%
66	1	0.1%
65	4	0.4%
64	1	0.1%

val
Real number (ℝ_≥0)

Distinct	93
Distinct (%)	9.3%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	50.901

Minimum	4
Maximum	97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	4
5-th percentile	17
Q1	35
median	50.5
Q3	68
95-th percentile	87
Maximum	97
Range	93
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	21.56339906
Coefficient of variation (CV)	0.4236340949
Kurtosis	-0.8563255672
Mean	50.901
Median Absolute Deviation (MAD)	16.5
Skewness	0.0477864545
Sum	50901
Variance	464.9801792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45	26	2.6%
74	22	2.2%
35	21	2.1%
54	21	2.1%
42	20	2.0%
34	19	1.9%
59	19	1.9%
40	19	1.9%
36	19	1.9%
46	18	1.8%
Other values (83)	796	79.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	0.1%
5	1	0.1%
7	1	0.1%
8	4	0.4%
9	1	0.1%
10	6	0.6%
11	8	0.8%
12	4	0.4%
13	5	0.5%
14	5	0.5%

Value	Count	Frequency (%)
97	2	0.2%
96	4	0.4%
95	3	0.3%
94	4	0.4%
93	8	0.8%
92	3	0.3%
91	2	0.2%
90	2	0.2%
89	4	0.4%
88	13	1.3%

dur
Real number (ℝ_≥0)

Distinct	176
Distinct (%)	17.6%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	220.406

Minimum	113
Maximum	688
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	113
5-th percentile	169.95
Q1	197
median	216
Q3	237
95-th percentile	288
Maximum	688
Range	575
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	39.92767691
Coefficient of variation (CV)	0.1811551269
Kurtosis	21.12107027
Mean	220.406
Median Absolute Deviation (MAD)	20
Skewness	2.406328882
Sum	220406
Variance	1594.219383
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201	21	2.1%
214	21	2.1%
228	18	1.8%
199	17	1.7%
206	17	1.7%
200	17	1.7%
221	17	1.7%
215	17	1.7%
234	16	1.6%
202	16	1.6%
Other values (166)	823	82.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
113	1	0.1%
115	1	0.1%
119	1	0.1%
122	1	0.1%
124	1	0.1%
126	1	0.1%
129	1	0.1%
131	3	0.3%
135	1	0.1%
137	1	0.1%

Value	Count	Frequency (%)
688	1	0.1%
484	1	0.1%
418	1	0.1%
354	2	0.2%
350	1	0.1%
348	1	0.1%
343	1	0.1%
338	1	0.1%
337	1	0.1%
332	1	0.1%

acous
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	89
Distinct (%)	8.9%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	14.369

Minimum	0
Maximum	98
Zeros	134
Zeros (%)	13.4%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	19
95-th percentile	59
Maximum	98
Range	98
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	19.45403039
Coefficient of variation (CV)	1.353888954
Kurtosis	4.312550104
Mean	14.369
Median Absolute Deviation (MAD)	5
Skewness	2.078699941
Sum	14369
Variance	378.4592983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	134	13.4%
1	108	10.8%
2	75	7.5%
3	68	6.8%
4	52	5.2%
5	43	4.3%
6	34	3.4%
11	30	3.0%
9	28	2.8%
8	28	2.8%
Other values (79)	400	39.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	134	13.4%
1	108	10.8%
2	75	7.5%
3	68	6.8%
4	52	5.2%
5	43	4.3%
6	34	3.4%
7	21	2.1%
8	28	2.8%
9	28	2.8%

Value	Count	Frequency (%)
98	1	0.1%
97	1	0.1%
95	2	0.2%
94	1	0.1%
93	4	0.4%
92	2	0.2%
90	1	0.1%
88	2	0.2%
87	1	0.1%
86	1	0.1%

spch
Real number (ℝ_≥0)

Distinct	50
Distinct (%)	5.0%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	10.064

Minimum	2
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	4
median	6
Q3	12
95-th percentile	31.05
Maximum	53
Range	51
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	9.276743069
Coefficient of variation (CV)	0.9217749472
Kurtosis	3.780643668
Mean	10.064
Median Absolute Deviation (MAD)	3
Skewness	1.9870704
Sum	10064
Variance	86.05796196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	175	17.4%
3	138	13.8%
5	138	13.8%
6	69	6.9%
7	56	5.6%
9	51	5.1%
8	47	4.7%
10	38	3.8%
14	25	2.5%
11	24	2.4%
Other values (40)	239	23.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	3	0.3%
3	138	13.8%
4	175	17.4%
5	138	13.8%
6	69	6.9%
7	56	5.6%
8	47	4.7%
9	51	5.1%
10	38	3.8%
11	24	2.4%

Value	Count	Frequency (%)
53	1	0.1%
52	1	0.1%
51	1	0.1%
49	1	0.1%
48	1	0.1%
47	1	0.1%
46	2	0.2%
45	2	0.2%
44	1	0.1%
43	3	0.3%

pop
Real number (ℝ_≥0)

Distinct	55
Distinct (%)	5.5%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	74.84

Minimum	35
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	35
5-th percentile	59
Q1	70
median	76
Q3	81
95-th percentile	87
Maximum	95
Range	60
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.807836169
Coefficient of variation (CV)	0.1176888852
Kurtosis	1.504825813
Mean	74.84
Median Absolute Deviation (MAD)	5
Skewness	-0.9334162419
Sum	74840
Variance	77.57797798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
77	64	6.4%
78	54	5.4%
81	51	5.1%
74	48	4.8%
80	46	4.6%
76	46	4.6%
71	45	4.5%
75	43	4.3%
83	41	4.1%
82	39	3.9%
Other values (45)	523	52.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
35	1	0.1%
39	2	0.2%
40	1	0.1%
41	1	0.1%
42	1	0.1%
43	1	0.1%
44	1	0.1%
45	1	0.1%
46	1	0.1%
48	1	0.1%

Value	Count	Frequency (%)
95	1	0.1%
94	1	0.1%
91	6	0.6%
90	2	0.2%
89	12	1.2%
88	18	1.8%
87	16	1.6%
86	29	2.9%
85	32	3.2%
84	34	3.4%

top year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	1.0%
Missing	3
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	2014.5

Minimum	2010
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 KiB

Quantile statistics

Minimum	2010
5-th percentile	2010
Q1	2012
median	2014.5
Q3	2017
95-th percentile	2019
Maximum	2019
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.873718542
Coefficient of variation (CV)	0.001426517023
Kurtosis	-1.224361662
Mean	2014.5
Median Absolute Deviation (MAD)	2.5
Skewness	0
Sum	2014500
Variance	8.258258258
Monotonicity	Increasing

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2010	100	10.0%
2011	100	10.0%
2012	100	10.0%
2013	100	10.0%
2014	100	10.0%
2015	100	10.0%
2016	100	10.0%
2017	100	10.0%
2018	100	10.0%
2019	100	10.0%
(Missing)	3	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2010	100	10.0%
2011	100	10.0%
2012	100	10.0%
2013	100	10.0%
2014	100	10.0%
2015	100	10.0%
2016	100	10.0%
2017	100	10.0%
2018	100	10.0%
2019	100	10.0%

Value	Count	Frequency (%)
2019	100	10.0%
2018	100	10.0%
2017	100	10.0%
2016	100	10.0%
2015	100	10.0%
2014	100	10.0%
2013	100	10.0%
2012	100	10.0%
2011	100	10.0%
2010	100	10.0%

artist type
Categorical

Distinct	4
Distinct (%)	0.4%
Missing	3
Missing (%)	0.3%
Memory size	8.0 KiB

Solo	748
Band/Group	169
Duo	70
Trio	13

Length

Max length	10
Median length	4
Mean length	4.944
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Duo
2nd row	Duo
3rd row	Solo
4th row	Solo
5th row	Solo

Common Values

Value	Count	Frequency (%)
Solo	748	74.6%
Band/Group	169	16.8%
Duo	70	7.0%
Trio	13	1.3%
(Missing)	3	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
solo	748	74.8%
band/group	169	16.9%
duo	70	7.0%
trio	13	1.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	title	artist	top genre	year released	added	bpm	nrgy	dnce	dB	live	val	dur	acous	spch	pop	top year	artist type
0	STARSTRUKK (feat. Katy Perry)	3OH!3	dance pop	2009.0	2022‑02‑17	140.0	81.0	61.0	-6.0	23.0	23.0	203.0	0.0	6.0	70.0	2010.0	Duo
1	My First Kiss (feat. Ke$ha)	3OH!3	dance pop	2010.0	2022‑02‑17	138.0	89.0	68.0	-4.0	36.0	83.0	192.0	1.0	8.0	68.0	2010.0	Duo
2	I Need A Dollar	Aloe Blacc	pop soul	2010.0	2022‑02‑17	95.0	48.0	84.0	-7.0	9.0	96.0	243.0	20.0	3.0	72.0	2010.0	Solo
3	Airplanes (feat. Hayley Williams of Paramore)	B.o.B	atl hip hop	2010.0	2022‑02‑17	93.0	87.0	66.0	-4.0	4.0	38.0	180.0	11.0	12.0	80.0	2010.0	Solo
4	Nothin' on You (feat. Bruno Mars)	B.o.B	atl hip hop	2010.0	2022‑02‑17	104.0	85.0	69.0	-6.0	9.0	74.0	268.0	39.0	5.0	79.0	2010.0	Solo
5	Magic (feat. Rivers Cuomo)	B.o.B	atl hip hop	2010.0	2022‑02‑17	82.0	93.0	55.0	-4.0	35.0	79.0	196.0	1.0	34.0	71.0	2010.0	Solo
6	The Time (Dirty Bit)	Black Eyed Peas	dance pop	2010.0	2022‑02‑17	128.0	81.0	82.0	-8.0	60.0	44.0	308.0	7.0	7.0	75.0	2010.0	Band/Group
7	Imma Be	Black Eyed Peas	dance pop	2009.0	2022‑02‑17	92.0	52.0	60.0	-7.0	31.0	41.0	258.0	18.0	37.0	71.0	2010.0	Band/Group
8	Talking to the Moon	Bruno Mars	dance pop	2010.0	2022‑02‑17	146.0	59.0	50.0	-5.0	11.0	8.0	218.0	51.0	3.0	87.0	2010.0	Solo
9	Just the Way You Are	Bruno Mars	dance pop	2010.0	2022‑02‑17	109.0	84.0	64.0	-5.0	6.0	42.0	221.0	1.0	4.0	86.0	2010.0	Solo

Last rows

	title	artist	top genre	year released	added	bpm	nrgy	dnce	dB	live	val	dur	acous	spch	pop	top year	artist type
993	Cruel Summer	Taylor Swift	pop	2019.0	2021‑08‑17	170.0	70.0	55.0	-6.0	11.0	56.0	178.0	12.0	16.0	82.0	2019.0	Solo
994	You Need To Calm Down	Taylor Swift	pop	2019.0	2020‑06‑22	85.0	67.0	77.0	-6.0	6.0	71.0	171.0	1.0	6.0	81.0	2019.0	Solo
995	SICKO MODE	Travis Scott	hip hop	2018.0	2020‑06‑22	155.0	73.0	83.0	-4.0	12.0	45.0	313.0	1.0	22.0	86.0	2019.0	Solo
996	EARFQUAKE	Tyler, The Creator	hip hop	2019.0	2020‑06‑22	80.0	50.0	55.0	-9.0	80.0	41.0	190.0	23.0	7.0	85.0	2019.0	Solo
997	Boasty (feat. Idris Elba)	Wiley	grime	2019.0	2020‑06‑22	103.0	77.0	89.0	-5.0	9.0	46.0	177.0	1.0	7.0	68.0	2019.0	Solo
998	Strike a Pose (feat. Aitch)	Young T & Bugsey	afroswing	2019.0	2020‑08‑20	138.0	58.0	53.0	-6.0	10.0	59.0	214.0	1.0	10.0	67.0	2019.0	Duo
999	The London (feat. J. Cole & Travis Scott)	Young Thug	atl hip hop	2019.0	2020‑06‑22	98.0	59.0	80.0	-7.0	13.0	18.0	200.0	2.0	15.0	75.0	2019.0	Solo
1000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1001	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1002	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows